Release 10.1A: OpenEdge Data Management:
SQL Development

Connecting using SQL Explorer

SQL Explorer is a Java-based tool you can use to execute OpenEdge SQL statements, shell commands, and client control commands.

To start the SQL Explorer tool and connect to an OpenEdge database, execute a command using one of the following syntax examples:

sqlexp -db database-name -S port | service-name -H host -user userid -password password

sqlexp –url jdbc:datadirect:openedge://host:port;databaseName=db_name; servicename=service_name -user userid -password password

Notes: The –db preceding the database-name is optional.

host is optional and defaults to localhost, which is valid only for nonremote databases.

The user is optional and defaults to the current user. The user’s password is also optional and defaults to null.

The current user, when using the default, must be the user who created the OpenEdge database.

In Windows and on UNIX, a user and password are optional until the first user is created in the OpenEdge database.

Once the CREATE USER statement is executed, a user and password must be provided.